一.表结构及数据：

1.学生表及数据

create table Student

(

StudentId int primary key identity(1,1),

StudentName varchar(225) not null,

SchoolId int not null

);

insert into Student(StudentName,SchoolId) values ('Zzr', 1);

insert into Student(StudentName,SchoolId) values ('Ls', 2);

insert into Student(StudentName,SchoolId) values ('Wem', 3);

insert into Student(StudentName,SchoolId) values ('Hpf', 4);

insert into Student(StudentName,SchoolId) values ('Zzr', 5);

insert into Student(StudentName,SchoolId) values ('hpf', 2);

insert into Student(StudentName,SchoolId) values ('hpf', 2);

insert into Student(StudentName,SchoolId) values ('qwe', 0);

insert into Student(StudentName,SchoolId) values ('qwe', 0);

2.学校表及数据

create table School

(

SchoolId int primary key identity(1,1),

SchoolName varchar(225) not null,

);

insert into School(SchoolName) values ('一中');

insert into School(SchoolName) values ('二中');

insert into School(SchoolName) values ('三中');

insert into School(SchoolName) values ('四中');

insert into School(SchoolName) values ('五中');

二.单表分页查询：

int pageNumber = 1;//第几页（可随意修改查看结果）

int pageSize = 2;//每页多少数据

int totalNumber = 0;//总数据

List<Student> list = db.Queryable<Student>().ToPageList(pageNumber, pageSize, ref totalNumber);

三.异步单表分页查询：

int pageNumber = 1;//第几页

int pageSize = 2;//每页多少数据

RefAsync<int> totalNumber = 0;//总数据

List<Student> list = await db.Queryable<Student>().ToPageListAsync(pageNumber, pageSize, totalNumber);

四.多表分页查询:

int pageNumber = 1;//第几页

int pageSize = 2;//每页多少数据

int totalNumber = 0;//总数据

var cs = db.Queryable<Student, School>((st, sc) => new JoinQueryInfos(JoinType.Left, st.SchoolId == sc.SchoolId))

                .Select((st, sc) => new { Id = st.SchoolId, StudentName = st.Name, SchoolName = sc.SchoolName })

                .ToPageList(pageNumber, pageSize,ref totalNumber);

五.异步多表分页查询:

int pageNumber = 1;//第几页

int pageSize = 2;//每页多少数据

RefAsync<int> totalNumber = 0;//总数据

var cs =await db.Queryable<Student, School>((st, sc) => new JoinQueryInfos(JoinType.Left, st.SchoolId == sc.SchoolId))

                .Select((st, sc) => new { Id = st.SchoolId, StudentName = st.Name, SchoolName = sc.SchoolName })

                .ToPageListAsync(pageNumber, pageSize, totalNumber);